home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Wildcat Gold - The Optical BBS
/
Wildcat Gold - The Optical BBS (The Golden ROM Series)(Volume 4 Number 1)(The Digital Publishing Company)(1992).ISO
/
sdn
/
coll41a.sdn
/
COLL-A41.EXE
/
COLLECT.ACS
/
MERGE.DOC
< prev
next >
Wrap
Text File
|
1991-10-24
|
22KB
|
519 lines
Import or Output Data:
Import:
Import a 12 or 13 field ASCII "comma delimited" file.
see options '8' or '9'
Output:
WordStar[TM]/MailMerge[TM]/WordPerfect[TM]/Microsoft [TM] Word 4.0
dBASE III [TM]/SBT [TM]/SourceMate [TM] Output
Basica/Output Sequential File
Overview:
Options 1 - 7
These options create either a WordStar/MailMerge[TM], WordPerfect[TM], or ì
dBASE III [TM] data file using the data from your Prospect/dBASE III file. ì
The newly created file ends in the letters: '.DAT', .DEF', '.SF' or '.DBF'.
If used with Wordstar[TM], the .DAT file can be used to print form letters ì
in MailMerge[TM]. All character fields are trimmed of trailing blanks to ì
accommodate your form letters. Along with this data file, the Wordstar ì
option creates the beginning of your form letter and puts it in a file ì
ending in the 3 letters '.DEF' (containing all the MailMerge[TM] commands ì
you need at the start of a form letter).
If used with WordPerfect[TM], the .SF file is the 'Secondary File' that ì
WordPerfect uses for merge letters, where each field is delimited with ì
CONTROL-R, and each record is delimited with CONTROL-E.]
If used with dBASE III [TM], the '.DBF' file format is becoming a standard ì
data file format that many other programs are using for their respective ì
data import function.
When used with Microsoft [Reg. TM] Word 4.0, the '.DAT' file contains the ì
data or records that the Word 4.0 merge document requires.
Thesσá option≤ wil∞ allo≈ yo⌡ t∩ outpu⌠ thσ ke∙ field≤ iε you≥ Debtor filσ ì
t∩ aε externa∞ tex⌠ filσ tha⌠ can¼á iε turn¼á bσ useΣ b∙ ß worΣ processo≥ ì
t∩ creatσ 'boilerplateº o≥ forφ letter≤ fo≥ yo⌡ automatically.
Based on your selection criteria, if any, the program will output these ì
fields:
Sex ID, First name, Greeting, Last name, Company Name, Address1/2
City, State, Zip, Zip4, Phone number, Comments
==============
| OPTION 1: |
==============
Selection Process:
èAt option 1, you can input up to 7 search criteria as the basis for
your word processor merge file:
Last Name, First Name, Company, City, State, Zip,
and Comments.
You can select whether you want only those records to be selected that ì
have all of criteria in every record or select out records regardless of ì
the number of matches made per record, as long as at least one match is ì
made in any one record that is selected.
True [or T] means all matches have to be made in any one record for it to
be selected. False [or F] means that as long as one match is made in a
record it will be selected.
Search Criteria Selection:
Option 1:
Yo⌡á caεá ente≥á an∙á word¼á phrase¼á o≥ codσ oεá whicΦá t∩á basσá you≥ ì
selection«á Iµ lef⌠ blank¼á al∞ record≤ wil∞ bσ selecteΣ out« Iµ yo⌡ ì
makσá aε entr∙ here¼á thσ prograφ wil∞ searcΦ througΦ thσá Debtorá filσ ì
anΣ selec⌠ ou⌠ onl∙ thosσ record≤ tha⌠ mee⌠ you≥ searcΦ criteria.
[Note that you can have up to 7 different codes or phrases entered here and ì
all records will be pulled which have any one of them or any combination ì
of them]
==============
| OPTION 2: |
==============
2) Output records to Wordstar/Mailmerge[TM]
[outputs into a 12 field, comma delimited file]
fields outputted:
SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE-1
This option is used to get data from the Debtor file and output it to a ì
file that can be used by WordStar/MailMerge[TM]. This file can also be ì
used by BASIC and other languages and products. In short, any product that ì
accepts "comma delimited" files for input may accept the file created by ì
this option.
From the WordStar option, you will create two files. The first file name ì
ends in .DEF and is a file that can be turned into a form letter just by ì
calling it up in WordStar and matching it to your form letter. It already ì
contains all of the commands needed by WordStar to read the Prospect/dBASE ì
III data file (.DAT).
The other file is the .DAT file, which contains all data that you want to ì
read into WordStar. It is formatted sequential file, with all fields in ì
quotes and separated by commas.
è
==============
| OPTION 3: |
==============
3) Output records to WordPerfect[TM]
[outputs into a 14 field, CONTROL-R delimited file]
fields outputted:
SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2
The .SF file is the 'Secondary File' that WordPerfect uses for merge ì
letters, where each field is delimited with CONTROL-R, and each record is ì
delimited with CONTROL-E.]
Be sure to retrieve the 'Secondary File' into WordPerfect, at which time ì
WordPerfect will insert its printer codes. Then, while inside WordPerfect, ì
save the file under that same name. At this point, the 'Secondary File' ì
will be usable for purposes of mail merging.
[Similar to option B]
==============
| OPTION 4: |
==============
4) Output records to dBASE III [Registered TM]
With option 4, the '.DBF' file format is becoming a standard data file ì
format that many other programs are using for their respective data import ì
function.
Once you assign a name to the dBASE III [TM] file you are outputting, the ì
structure of that file is:
Field Field Name Type Width Dec
1 SEX Character 19
2 FNAME Character 20
3 GREETING Character 20
4 LNAME Character 20
5 PROSPECT Character 40
6 ADDRESS1 Character 30
7 ADDRESS2 Character 30
8 CITY Character 30
9 STATE Character 2
10 ZIP Numeric 5 < numeric representation of Zip codes
11 ZIP4 Numeric 4 < numeric representation of Zip+4 codes
12 ZIP_CH Character 5 < character representation of Zip codes
13 ZIP4_CH Character 4 < character representation of Zip+4 codes
14 PHONE_1 Character 13
15 COMMENT1 Character 60
16 COMMENT2 Character 60
17 CATEGORY Numeric 8è 18 PRIORITY Numeric 4
19 REFERBY Character 30
** Total ** 405
The numeric zip code fields drop leading zeros, while the character ones ì
add them back.
==============
| OPTION 5: |
==============
5) Output records to Microsoft [TM] Word 4.0
[outputs into a 12 field, comma delimited file]
fields outputted:
SEX, FNAME, GREETING, LNAME, PROSPECT, ADDRESS1,
ADDRESS2, CITY, STATE, ZIP, ZIP4, PHONE1
This option is used to get data from the Debtor file and output it to a ì
data file that can be used by the merge feature in Word 4.0..
Your Word 4.0 letter will contain merge variables of the form:
<<SEX>>
<<FNAME>>
<<GREETING>>
<<LNAME>>
<<PROSPECT>>
and so on. These merge variables are identified in the '.DEF' or header ì
file created by the program. These symbols, "<<" and ">>", are formed by ì
holding down the <ALT> key and typing 174 or 175.
At the top of your Word 4.0 letter, you will have this command (if you ì
select 'TEST' as the file name for outputting your data in option 5):
<<DATA TEST.DEF, TEST.DAT>>
This tells Word 4.0 to look into TEST.DEF for the header or identification ì
of fields used; and to pull in TEST.DAT for the data.
TEST.DAT is a 'comma delimited, ASCII file'. It contains all data that you ì
want to read into Word 4.0. It is formatted sequential file, with all ì
fields in quotes and separated by commas.
==============
| OPTION 6: |
==============
This option will append records directly to the SBT [TM] customer file.è
==============
| OPTION 7: |
==============
This option will append records directly to the SourceMate [TM] customer ì
file.
==============
| OPTION 8: |
==============
Import data from ASCII file:
Create an ASCII "comma delimited" file with these 12 fields:
First name <== up to 20 characters
Last name <== up to 20 characters
Company name <== up to 40 characters
Address 1 <== up to 30 characters, first line of address
Address 2 <== up to 30 characters, 2nd line, if any, such as
'Suite 214'
City <== up to 30 characters
State <== two character state, if U.S.A.; else leave blank
Zip <== U.S.A. Zip code, 5 characters
Zip4 <== U.S.A. Supplemental Zip code, 4 characters
Phone <== 13 character, if .U.S.A. or Canada. Must be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
Comment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Option 8 will import from an ASCII file named: 'AIMPORT.TXT'. Make ì
sure that your file has that name.
Observe below one record in the ASCII "comma delimited" format:
"John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
"Suite 101","Dallas","TX","75229","0234","(214)357-5454","SIC=4303",""
Observe that "Suite 101" would normally follow after "11056 Shady ì
Trail" on one continuous line. Here the record is broken into two ì
lines only for purposes of showing you how it looks.
==============
| OPTION 9: |
==============
Import data from ASCII file:
Create an ASCII "comma delimited" file with these 13 fields:
è First name <== up to 20 characters
Last name <== up to 20 characters
Company name <== up to 40 characters
Address 1 <== up to 30 characters, first line of address
Address 2 <== up to 30 characters, 2nd line, if any, such as
'Suite 214'
City <== up to 30 characters
State <== two character state, if U.S.A.; else leave blank
Zip <== U.S.A. Zip code, 5 characters
Zip4 <== U.S.A. Supplemental Zip code, 4 characters
Phone <== 13 character, if .U.S.A. or Canada. Must be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
Comment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Revenue/Expense<== Any value entered here will cause a corresponding
first record in the Activity file to be created.
Option 9 will import from an ASCII file named: 'AIMPORT.TXT'. Make ì
sure that your file has that name.
Observe below one record in the ASCII "comma delimited" format:
"John D.","Cauble, Jr.","Accounting & Tax Service","11056 Shady Trail",
"Suite 101","Dallas","TX","75229","0234","(214)357-5454",
"SIC=4303","Mr.","5412.43"
Observe that "Suite 101" would normally follow after "11056 Shady ì
Trail" on one continuous line. Here the record is broken into two ì
lines only for purposes of showing you how it looks. You are not ì
required to enter a value for the Revenue/Expense field. If you do, ì
then the program will create a corresponding record in the activity ì
file.
One application of this would be if you are bringing in records from an ì
Accounts Receivable file, with an amount owed for each debtor.
==============
| OPTION A: |
==============
"A) Select date range [works with #2,3,4,5 B and D only]"
Option A is to change the start or stop date on the options to Import or ì
Output Data. It defaults to these dates:
START DATE :'01/01/1901'
STOP DATE :'12/12/2999'
Note that this date range selection will work only with selections #2, 3, ì
4, and 5 on this menu.è
==============
| OPTION B: |
==============
B) Output records to WordPerfect[TM]
[outputs into a 17 field, CONTROL-R delimited file]
fields outputted:
SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY
The .SF file is the 'Secondary File' that WordPerfect uses for merge ì
letters, where each field is delimited with CONTROL-R, and each record is ì
delimited with CONTROL-E.]
Be sure to retrieve the 'Secondary File' into WordPerfect, at which time ì
WordPerfect will insert its printer codes. Then, while inside WordPerfect, ì
save the file under that same name. At this point, the 'Secondary File' ì
will be usable for purposes of mail merging.
[Similar to option 3]
==============
| OPTION C: |
==============
Import data from ASCII file:
Create an ASCII "comma delimited" file with these 24 fields:
[Bring data into Prospect Detail File]
First name <== up to 20 characters
Last name <== up to 20 characters
Company name <== up to 40 characters
Address 1 <== up to 30 characters, first line of address
Address 2 <== up to 30 characters, 2nd line, if any, such as
'Suite 214'
City <== up to 30 characters
State <== two character state, if U.S.A.; else leave blank
Zip <== U.S.A. Zip code, 5 characters
Zip4 <== U.S.A. Supplemental Zip code, 4 characters
Phone <== 13 character, if .U.S.A. or Canada. Must be
in this form: (214)690-6017
Observe character 1 is '(', 5 is ')', and 9 is '-'
Comment1 <== any comment, up to 60 characters
Sex ID <== if used, such as 'Dr.', 'Captain', or 'Reverend'
Detail 1 <== up to 20 characters, placed into Debtor Detail File,
field one.
Detail 2 <== up to 20 charactersè Detail 3 <== up to 20 characters
Detail 4 <== up to 20 characters
Detail 5 <== up to 20 characters
Detail 6 <== up to 20 characters
Detail 7 <== up to 20 characters
Detail 8 <== up to 20 characters
Detail 9 <== up to 20 characters
Detail 10 <== up to 20 characters
Detail 11 <== up to 20 characters
Detail 12 <== up to 20 characters
Option C will import from an ASCII file named: 'AIMPORT.TXT'. Make ì
sure that your file has that name.
Observe below one record in the ASCII "comma delimited" format:
"Alyce","Fisher","P.O. BOX","2116 E. Arapaho","P.O. Box 3823","Richardson",
"TX","75081","0433","(214)783-8581",
"they currently have an 8bit system, written in compiled",
"Mr.","DET1","DET2","DET3","DET4","DET5","DET6","DET7","DET8",
"DET9","DET10","DET11","DET12"
Observe that this record would normally be on one continuous line, but is ì
here broken into five lines only for purposes of showing you how it looks.
==============
| OPTION D: |
==============
D) Output records to WordPerfect[TM]
[outputs into a 19 field, CONTROL-R delimited file]
fields outputted:
SEX,FNAME,GREETING,LNAME,PROSPECT,ADDRESS1,ADDRESS2,CITY,STATE
ZIP,ZIP4,PHONE-1,COMMENT1,COMMENT2,CATEGORY,PRIORITY,REFERBY
DATE,AMOUNT
The .SF file is the 'Secondary File' that WordPerfect uses for merge ì
letters, where each field is delimited with CONTROL-R, and each record is ì
delimited with CONTROL-E.]
Be sure to retrieve the 'Secondary File' into WordPerfect, at which time ì
WordPerfect will insert its printer codes. Then, while inside WordPerfect, ì
save the file under that same name. At this point, the 'Secondary File' ì
will be usable for purposes of mail merging.
'DATE' is the date of original entry into the program. 'AMOUNT' is the ì
revenue/expense item.
[Similar to option 3]è
==============
| OPTION E: |
==============
"E) Dun's [TM] ASCII import"
Dun's Marketing Services [TM] offers an outstanding database inquiry ì
service for sales and marketing professionals called Dun's Direct Access ì
[TM]. For more information on their offerings, please call:
Dun's Marketing Services
Three Sylvan Way
Parsippany, NJ 07054 -3896
(800)624-5669
(201)605-6424
Within their system, Dun's [TM] offers an 'ASCII Fixed Field' output ì
option. For every record you request, Dun's [TM] will output 203 ì
characters or columns into a 'TXT' file.
Once option E identifies the presence of 'DUNS.TXT', then this program will ì
import all of its fields correctly.
Dun's [TM] outputs its fields in this form:
Field Field Name Type Width Columns
1 FNAME Character 13 1 - 13
2 LNAME Character 15 14 - 28
3 PROSPECT Character 30 29 - 58
4 ADDRESS1 Character 25 59 - 83
5 ADDRESS2 Character 25 84 - 108
6 CITY Character 20 109 - 128
7 STATE Character 2 129 - 130
8 ZIP Character 5 131 - 135
9 ZIP 4 Character 4 136 - 139
10 MISC Character 4 140 - 143
11 PHONE Character 10 144 - 153
12 BUSINESS Character 19 154 - 172
13 MISC1 Character 1 173 - 173
14 TITLE Character 30 174 - 203
Note that ADDRESS2, if used, is their representation of a mailing address. ì
This information is moved into the incoming comment field since it is ì
incomplete as outputted in their 'TXT' file. The zip code that accompanies ì
their ADDRESS2 is retained internally in the Dun's Direct Access [TM] ì
system and displayed during their queries, but is not outputted in their ì
ASCII format.
'MISC' and 'MISC1' are ignored when option E imports the data.è
To see an actual example of their data, observe 'SAMPLDUN.TXT' in this ì
subdirectory. As you exit this program, please invoke:
LIST SAMPLDUN.TXT <============= You enter this
===== Logic of "ATTN:" =====
When option E senses a value in the TITLE field, it attempts to place a ì
value into Address 2 of the incoming record, applying this logic:
1) If between 1 and 24 characters, the entire TITLE is placed ì
into Address 2 in this form:
ATTN:President
2) If between 25 and 28 characters, it places this text into ì
Address 2:
[Directory of Student Svcs]
3) If greater than 28 characters, this phrase appears in Comment ì
1:
Title=Directory of Corporate Planning
Dun's [TM] and Dun's Direct Access [TM] are trademarks of The Dun & ì
Bradstreet Corporation. All sample data contained in 'SAMPLDUN.TXT' is ì
property of The Dun & Bradstreet Corporation.